# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月15日
"""
import openpyxl

myBook=openpyxl.load_workbook('录取表.xlsx',data_only=True)

mySheet1=myBook['北京大学录取表']
mySheet2=myBook['清华大学录取表']
mySheet3=myBook['浙江大学录取表']
mySheet4=myBook['武汉大学录取表']
mySheet5=myBook.copy_worksheet(mySheet1)
mySheet5.title='录取表'
while mySheet5.max_row>1:
	mySheet5.delete_rows(2)

mySet1=set(list(mySheet1.values)[1:])
mySet2=set(list(mySheet2.values)[1:])
mySet3=set(list(mySheet3.values)[1:])
mySet4=set(list(mySheet4.values)[1:])

mySet5=mySet1.union(mySet2,mySet3,mySet4)
for myRow in mySet5:
	mySheet5.append(myRow)
myBook.save('结果表-录取表.xlsx')